package com.fengsir.exp4.mapper;

import com.fengsir.exp4.entity.Student;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 * @author fengzeng
 */
@Mapper
public interface StudentMapper {

    @Insert("INSERT INTO `course`.`exp_stu`(`stuno`, `name`, `sex`, `score`) VALUES (#{stuno}, #{name}, #{sex}, #{score})")
    int insert(Student record);

    @Select("select * from exp_stu where stuno=#{stuno}")
    Student selectStudent(Integer stuno);
}